<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>i2c: C:/Users/Jon/Downloads/OOP/db-control/inc/dbInstallSandbox.php Source File</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />

<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>

</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">i2c
   
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.7.5.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="pages.html"><span>Related&#160;Pages</span></a></li>
      <li><a href="annotated.html"><span>Data&#160;Structures</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>Globals</span></a></li>
    </ul>
  </div>
<div class="header">
  <div class="headertitle">
<div class="title">C:/Users/Jon/Downloads/OOP/db-control/inc/dbInstallSandbox.php</div>  </div>
</div>
<div class="contents">
<a href="db_install_sandbox_8php.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 &lt;?php
<a name="l00002"></a>00002 
<a name="l00003"></a>00003 error_reporting(<span class="stringliteral">&#39;E_ALL &amp; ~E_NOTICE&#39;</span>);
<a name="l00016"></a>00016 include(<span class="stringliteral">&#39;functions.php&#39;</span>);
<a name="l00017"></a>00017 include(<span class="stringliteral">&#39;../dbOrganization.php&#39;</span>);
<a name="l00018"></a>00018 include(<span class="stringliteral">&#39;../../model/Organization.php&#39;</span>);
<a name="l00019"></a>00019 include(<span class="stringliteral">&#39;../dbCategory.php&#39;</span>);
<a name="l00020"></a>00020 include(<span class="stringliteral">&#39;../../model/Category.php&#39;</span>);
<a name="l00021"></a>00021 include(<span class="stringliteral">&#39;../dbContact.php&#39;</span>);
<a name="l00022"></a>00022 include(<span class="stringliteral">&#39;../../model/Contact.php&#39;</span>);
<a name="l00023"></a>00023 include(<span class="stringliteral">&#39;../dbStudent.php&#39;</span>);
<a name="l00024"></a>00024 include(<span class="stringliteral">&#39;../../model/Student.php&#39;</span>);
<a name="l00025"></a>00025 include(<span class="stringliteral">&#39;../dbOpportunity.php&#39;</span>);
<a name="l00026"></a>00026 include(<span class="stringliteral">&#39;../../model/Opportunity.php&#39;</span>);
<a name="l00027"></a>00027 include(<span class="stringliteral">&#39;../dbMajor.php&#39;</span>);
<a name="l00028"></a>00028 include(<span class="stringliteral">&#39;../../model/Major.php&#39;</span>);
<a name="l00029"></a>00029 include(<span class="stringliteral">&#39;../dbInternship.php&#39;</span>);
<a name="l00030"></a>00030 include(<span class="stringliteral">&#39;../../model/Internship.php&#39;</span>);
<a name="l00031"></a>00031 include(<span class="stringliteral">&#39;../dbUser.php&#39;</span>);
<a name="l00032"></a>00032 include(<span class="stringliteral">&#39;../../model/User.php&#39;</span>);
<a name="l00033"></a>00033 
<a name="l00034"></a>00034 echo (<span class="stringliteral">&quot;Initializing Data...&lt;br /&gt;&quot;</span>);
<a name="l00035"></a>00035 
<a name="l00036"></a>00036 <span class="comment">//one call does all he work of populating the database with sample data</span>
<a name="l00037"></a>00037 <a class="code" href="db_install_sandbox_8php.html#ad426b65104577e2839255f998dcb11f2">populateDatabase</a>();
<a name="l00038"></a>00038 
<a name="l00044"></a><a class="code" href="db_install_sandbox_8php.html#ad426b65104577e2839255f998dcb11f2">00044</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#ad426b65104577e2839255f998dcb11f2">populateDatabase</a>() {
<a name="l00045"></a>00045 <span class="comment">//Category</span>
<a name="l00046"></a>00046     $id = 0;
<a name="l00047"></a>00047     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Advertising/Graphic Design&#39;</span>, $id);
<a name="l00048"></a>00048     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00049"></a>00049 
<a name="l00050"></a>00050     $id = 0;
<a name="l00051"></a>00051     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;CIS Related&#39;</span>, $id);
<a name="l00052"></a>00052     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00053"></a>00053 
<a name="l00054"></a>00054     $id = 0;
<a name="l00055"></a>00055     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Communications&#39;</span>, $id);
<a name="l00056"></a>00056     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00057"></a>00057 
<a name="l00058"></a>00058     $id = 0;
<a name="l00059"></a>00059     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Community Service&#39;</span>, $id);
<a name="l00060"></a>00060     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00061"></a>00061 
<a name="l00062"></a>00062     $id = 0;
<a name="l00063"></a>00063     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Educational&#39;</span>, $id);
<a name="l00064"></a>00064     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00065"></a>00065 
<a name="l00066"></a>00066     $id = 0;
<a name="l00067"></a>00067     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Event Planning&#39;</span>, $id);
<a name="l00068"></a>00068     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00069"></a>00069 
<a name="l00070"></a>00070     $id = 0;
<a name="l00071"></a>00071     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Finance/Economics&#39;</span>, $id);
<a name="l00072"></a>00072     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00073"></a>00073 
<a name="l00074"></a>00074     $id = 0;
<a name="l00075"></a>00075     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Government/Political&#39;</span>, $id);
<a name="l00076"></a>00076     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00077"></a>00077 
<a name="l00078"></a>00078     $id = 0;
<a name="l00079"></a>00079     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Health &amp; Human Services&#39;</span>, $id);
<a name="l00080"></a>00080     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00081"></a>00081 
<a name="l00082"></a>00082     $id = 0;
<a name="l00083"></a>00083     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Legal&#39;</span>, $id);
<a name="l00084"></a>00084     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00085"></a>00085 
<a name="l00086"></a>00086     $id = 0;
<a name="l00087"></a>00087     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Marketing/PR&#39;</span>, $id);
<a name="l00088"></a>00088     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00089"></a>00089 
<a name="l00090"></a>00090     $id = 0;
<a name="l00091"></a>00091     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Psychology&#39;</span>, $id);
<a name="l00092"></a>00092     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00093"></a>00093 
<a name="l00094"></a>00094     $id = 0;
<a name="l00095"></a>00095     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Research&#39;</span>, $id);
<a name="l00096"></a>00096     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00097"></a>00097 
<a name="l00098"></a>00098     $id = 0;
<a name="l00099"></a>00099     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Sales&#39;</span>, $id);
<a name="l00100"></a>00100     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00101"></a>00101 
<a name="l00102"></a>00102     $id = 0;
<a name="l00103"></a>00103     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Technology&#39;</span>, $id);
<a name="l00104"></a>00104     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00105"></a>00105 
<a name="l00106"></a>00106     $id = 0;
<a name="l00107"></a>00107     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Various&#39;</span>, $id);
<a name="l00108"></a>00108     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00109"></a>00109 
<a name="l00110"></a>00110     $id = 0;
<a name="l00111"></a>00111     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Web/Information Technology&#39;</span>, $id);
<a name="l00112"></a>00112     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00113"></a>00113 
<a name="l00114"></a>00114     $id = 0;
<a name="l00115"></a>00115     <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>(<span class="stringliteral">&#39;Writing/Journalism&#39;</span>, $id);
<a name="l00116"></a>00116     <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id);
<a name="l00117"></a>00117 
<a name="l00118"></a>00118 <span class="comment">//ORGANIZATION</span>
<a name="l00119"></a>00119     <span class="comment">//HAM (1)</span>
<a name="l00120"></a>00120     $id = 0;
<a name="l00121"></a>00121     <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<span class="stringliteral">&quot;Ham&quot;</span>, <span class="stringliteral">&quot;blue&quot;</span>, <span class="stringliteral">&quot;123 Cat Dr.&quot;</span>, <span class="stringliteral">&quot;Suite #5&quot;</span>,
<a name="l00122"></a>00122             <span class="stringliteral">&quot;Manchester&quot;</span>, <span class="stringliteral">&quot;NH&quot;</span>, <span class="stringliteral">&quot;03031&quot;</span>, $id);
<a name="l00123"></a>00123     <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id);
<a name="l00124"></a>00124 
<a name="l00125"></a>00125     <span class="comment">//PUP N SUDS (2)</span>
<a name="l00126"></a>00126     <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<span class="stringliteral">&quot;Pup N Suds&quot;</span>, <span class="stringliteral">&quot;They sponsored BRINK!&quot;</span>, <span class="stringliteral">&quot;123 Main Street&quot;</span>, null, <span class="stringliteral">&quot;Concord&quot;</span>, <span class="stringliteral">&quot;NH&quot;</span>, <span class="stringliteral">&quot;03031&quot;</span>, $id);
<a name="l00127"></a>00127     <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id);
<a name="l00128"></a>00128 
<a name="l00130"></a>00130     <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<span class="stringliteral">&quot;Boston Bruins&quot;</span>, <span class="stringliteral">&quot;Only the best hockey team ever!!!&quot;</span>, <span class="stringliteral">&quot;100 Legends Way&quot;</span>, null, <span class="stringliteral">&quot;Boston&quot;</span>, <span class="stringliteral">&quot;MA&quot;</span>, <span class="stringliteral">&quot;02114&quot;</span>, $id);
<a name="l00131"></a>00131     <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id);
<a name="l00132"></a>00132 
<a name="l00134"></a>00134     <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<span class="stringliteral">&quot;Microsoft&quot;</span>, <span class="stringliteral">&quot;Do stuff&quot;</span>, <span class="stringliteral">&quot;6 Main Street&quot;</span>, null,
<a name="l00135"></a>00135             <span class="stringliteral">&quot;Nashua&quot;</span>, <span class="stringliteral">&quot;New Hampshire&quot;</span>, <span class="stringliteral">&quot;12134&quot;</span>, $id);
<a name="l00136"></a>00136     <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id);
<a name="l00137"></a>00137 
<a name="l00139"></a>00139     <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<span class="stringliteral">&quot;Apple&quot;</span>, <span class="stringliteral">&quot;Do stuff with computers that look like an apple&quot;</span>, <span class="stringliteral">&quot;48329 Brookview Drive&quot;</span>, null, <span class="stringliteral">&quot;Londonderry&quot;</span>,
<a name="l00140"></a>00140             <span class="stringliteral">&quot;NH&quot;</span>, <span class="stringliteral">&quot;95014&quot;</span>, $id);
<a name="l00141"></a>00141     <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id);
<a name="l00142"></a>00142 
<a name="l00144"></a>00144     <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<span class="stringliteral">&quot;University of New Hampshire&quot;</span>, <span class="stringliteral">&quot;School in the middle of no where&quot;</span>, <span class="stringliteral">&quot;340 Dame Road&quot;</span>, null, <span class="stringliteral">&quot;Durham&quot;</span>, <span class="stringliteral">&quot;NH&quot;</span>,
<a name="l00145"></a>00145             <span class="stringliteral">&quot;03824&quot;</span>, $id);
<a name="l00146"></a>00146     <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id);
<a name="l00147"></a>00147 
<a name="l00149"></a>00149     <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<span class="stringliteral">&quot;Wal-mart&quot;</span>, <span class="stringliteral">&quot;Destroyed the economy and made China huge&quot;</span>, <span class="stringliteral">&quot;83 Long Way&quot;</span>, null, <span class="stringliteral">&quot;Salem&quot;</span>, <span class="stringliteral">&quot;NH&quot;</span>, <span class="stringliteral">&quot;39205&quot;</span>, $id);
<a name="l00150"></a>00150     <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id);
<a name="l00151"></a>00151 
<a name="l00153"></a>00153     <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<span class="stringliteral">&quot;Facebook&quot;</span>, <span class="stringliteral">&quot;Social Network&quot;</span>, <span class="stringliteral">&quot;2383 Main Street&quot;</span>,
<a name="l00154"></a>00154             null, <span class="stringliteral">&quot;Dracut&quot;</span>, <span class="stringliteral">&quot;MA&quot;</span>, <span class="stringliteral">&quot;39205&quot;</span>, $id);
<a name="l00155"></a>00155     <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id);
<a name="l00156"></a>00156 
<a name="l00158"></a>00158     <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<span class="stringliteral">&quot;Bain&quot;</span>, <span class="stringliteral">&quot;Bain and Company is a global management consulting firm.&quot;</span>, <span class="stringliteral">&quot;131 Dartmouth Street&quot;</span>, null, <span class="stringliteral">&quot;Boston&quot;</span>, <span class="stringliteral">&quot;MA&quot;</span>,
<a name="l00159"></a>00159             <span class="stringliteral">&quot;02199&quot;</span>, $id);
<a name="l00160"></a>00160     <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id);
<a name="l00161"></a>00161 
<a name="l00163"></a>00163     <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<span class="stringliteral">&quot;Parkland Medical Center&quot;</span>, <span class="stringliteral">&quot;Hospital&quot;</span>, <span class="stringliteral">&quot;1 Parkland Drive&quot;</span>, null, <span class="stringliteral">&quot;Derry&quot;</span>, <span class="stringliteral">&quot;NH&quot;</span>, <span class="stringliteral">&quot;03038&quot;</span>, $id);
<a name="l00164"></a>00164     <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id);
<a name="l00165"></a>00165 
<a name="l00166"></a>00166 <span class="comment">//CONTACT</span>
<a name="l00167"></a>00167     $id = 0;
<a name="l00168"></a>00168     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(1, <span class="stringliteral">&quot;Smith&quot;</span>, <span class="stringliteral">&quot;Ben&quot;</span>, <span class="stringliteral">&quot;BSmith@aol.com&quot;</span>, <span class="stringliteral">&quot;999-999-9999&quot;</span>,
<a name="l00169"></a>00169                     <span class="stringliteral">&quot;111&quot;</span>, <span class="stringliteral">&quot;111-111-1111&quot;</span>, $id);
<a name="l00170"></a>00170     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00171"></a>00171     
<a name="l00172"></a>00172     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(1, <span class="stringliteral">&quot;Sara&quot;</span>, <span class="stringliteral">&quot;McAwesome&quot;</span>, <span class="stringliteral">&quot;BSmith@aol.com&quot;</span>, <span class="stringliteral">&quot;999-999-9999&quot;</span>,
<a name="l00173"></a>00173                     <span class="stringliteral">&quot;111&quot;</span>, <span class="stringliteral">&quot;111-111-1111&quot;</span>, $id);
<a name="l00174"></a>00174     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00175"></a>00175     
<a name="l00176"></a>00176     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(1, <span class="stringliteral">&quot;Harry&quot;</span>, <span class="stringliteral">&quot;Frankenstein&quot;</span>, <span class="stringliteral">&quot;BSmith@aol.com&quot;</span>, <span class="stringliteral">&quot;999-999-9999&quot;</span>,
<a name="l00177"></a>00177                     <span class="stringliteral">&quot;111&quot;</span>, <span class="stringliteral">&quot;111-111-1111&quot;</span>, $id);
<a name="l00178"></a>00178     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00179"></a>00179 
<a name="l00180"></a>00180     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(2, <span class="stringliteral">&quot;Happy&quot;</span>, <span class="stringliteral">&quot;Gilmore&quot;</span>, null, null,
<a name="l00181"></a>00181                     null, null, $id);
<a name="l00182"></a>00182     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00183"></a>00183 
<a name="l00184"></a>00184     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(3, <span class="stringliteral">&quot;Patrice&quot;</span>, <span class="stringliteral">&quot;Bergeron&quot;</span>, null, null,
<a name="l00185"></a>00185                     null, null, $id);
<a name="l00186"></a>00186     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00187"></a>00187     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(4, <span class="stringliteral">&quot;Daniel&quot;</span>, <span class="stringliteral">&quot;Pepin&quot;</span>, <span class="stringliteral">&quot;BSmith@aol.com&quot;</span>, <span class="stringliteral">&quot;999-999-9999&quot;</span>,
<a name="l00188"></a>00188                     <span class="stringliteral">&quot;111&quot;</span>, <span class="stringliteral">&quot;111-111-1111&quot;</span>, $id);
<a name="l00189"></a>00189     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00190"></a>00190 
<a name="l00191"></a>00191     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(5, <span class="stringliteral">&quot;John&quot;</span>, <span class="stringliteral">&quot;Smith&quot;</span>, null, null,
<a name="l00192"></a>00192                     null, null, $id);
<a name="l00193"></a>00193     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00194"></a>00194 
<a name="l00195"></a>00195     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(6, <span class="stringliteral">&quot;Jeremy&quot;</span>, <span class="stringliteral">&quot;Something&quot;</span>, null, null,
<a name="l00196"></a>00196                     null, null, $id);
<a name="l00197"></a>00197     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00198"></a>00198     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(7, <span class="stringliteral">&quot;David&quot;</span>, <span class="stringliteral">&quot;Something&quot;</span>, <span class="stringliteral">&quot;BSmith@aol.com&quot;</span>, <span class="stringliteral">&quot;999-999-9999&quot;</span>,
<a name="l00199"></a>00199                     <span class="stringliteral">&quot;111&quot;</span>, <span class="stringliteral">&quot;111-111-1111&quot;</span>, $id);
<a name="l00200"></a>00200     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00201"></a>00201 
<a name="l00202"></a>00202     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(8, <span class="stringliteral">&quot;William&quot;</span>, <span class="stringliteral">&quot;Hung&quot;</span>, null, null,
<a name="l00203"></a>00203                     null, null, $id);
<a name="l00204"></a>00204     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00205"></a>00205 
<a name="l00206"></a>00206     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(9, <span class="stringliteral">&quot;Thomas&quot;</span>, <span class="stringliteral">&quot;Rice&quot;</span>, null, null,
<a name="l00207"></a>00207                     null, null, $id);
<a name="l00208"></a>00208     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00209"></a>00209     
<a name="l00210"></a>00210     <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>(10, <span class="stringliteral">&quot;Smitty&quot;</span>, <span class="stringliteral">&quot;Wergeryegermanjenson&quot;</span>, null, null,
<a name="l00211"></a>00211                     null, null, $id);
<a name="l00212"></a>00212     <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id);
<a name="l00213"></a>00213     
<a name="l00214"></a>00214 
<a name="l00215"></a>00215    <span class="comment">//STUDENT</span>
<a name="l00216"></a>00216     $id = 0;
<a name="l00217"></a>00217     <a class="code" href="db_install_sandbox_8php.html#a6690b1924436781ea9fc2e7d9b7a4fad">insertStudentData</a>(<span class="stringliteral">&quot;Jeff&quot;</span>, <span class="stringliteral">&quot;CarMichael&quot;</span>, <span class="stringliteral">&quot;Jcar&quot;</span>, 3.12, <span class="stringliteral">&quot;ENG&quot;</span>, <span class="stringliteral">&quot;Senior&quot;</span>,
<a name="l00218"></a>00218                     <span class="stringliteral">&quot;2011&quot;</span>, <span class="stringliteral">&quot;Yes&quot;</span>, $id);
<a name="l00219"></a>00219     <a class="code" href="db_install_sandbox_8php.html#a8094a4135599908646acd26c11023d38">verifyInsertedStudent</a>($id);
<a name="l00220"></a>00220 
<a name="l00221"></a>00221     <a class="code" href="db_install_sandbox_8php.html#a6690b1924436781ea9fc2e7d9b7a4fad">insertStudentData</a>(<span class="stringliteral">&quot;Bob&quot;</span>, <span class="stringliteral">&quot;Saget&quot;</span>, <span class="stringliteral">&quot;bsaget&quot;</span>, 3.19, <span class="stringliteral">&quot;ENG&quot;</span>, <span class="stringliteral">&quot;Super Senior&quot;</span>,
<a name="l00222"></a>00222                     <span class="stringliteral">&quot;2011&quot;</span>, <span class="stringliteral">&quot;Yes&quot;</span>, $id);
<a name="l00223"></a>00223     <a class="code" href="db_install_sandbox_8php.html#a8094a4135599908646acd26c11023d38">verifyInsertedStudent</a>($id);
<a name="l00224"></a>00224 
<a name="l00225"></a>00225     <a class="code" href="db_install_sandbox_8php.html#a6690b1924436781ea9fc2e7d9b7a4fad">insertStudentData</a>(<span class="stringliteral">&quot;Tyler&quot;</span>, <span class="stringliteral">&quot;Seguin&quot;</span>, <span class="stringliteral">&quot;tseguin&quot;</span>, 4.00, <span class="stringliteral">&quot;CIS&quot;</span>, <span class="stringliteral">&quot;Freshmen&quot;</span>,
<a name="l00226"></a>00226                     <span class="stringliteral">&quot;2015&quot;</span>, <span class="stringliteral">&quot;Yes&quot;</span>, $id);
<a name="l00227"></a>00227     <a class="code" href="db_install_sandbox_8php.html#a8094a4135599908646acd26c11023d38">verifyInsertedStudent</a>($id);
<a name="l00228"></a>00228 
<a name="l00229"></a>00229 <span class="comment">//OPPORTUNITY</span>
<a name="l00230"></a>00230     $id = 0;
<a name="l00231"></a>00231     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(1, 1, <span class="stringliteral">&quot;Programmer&quot;</span>, <span class="stringliteral">&quot;3&quot;</span>, <span class="stringliteral">&quot;2011 Spring&quot;</span>, <span class="stringliteral">&quot;500/week&quot;</span>,
<a name="l00232"></a>00232                     <span class="stringliteral">&quot;5 Weeks&quot;</span>, <span class="stringliteral">&quot;Design&quot;</span>, <span class="stringliteral">&quot;C++&quot;</span>, <span class="stringliteral">&quot;Go Left&quot;</span>, <span class="stringliteral">&quot;No Comment&quot;</span>,
<a name="l00233"></a>00233                     <span class="stringliteral">&quot;CIS Related Communications&quot;</span>, 1, $id);
<a name="l00234"></a>00234     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00235"></a>00235 
<a name="l00236"></a>00236     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(1, 2, <span class="stringliteral">&quot;System Administrator&quot;</span>, <span class="stringliteral">&quot;2&quot;</span>, <span class="stringliteral">&quot;2011 Fall&quot;</span>, <span class="stringliteral">&quot;15/hour&quot;</span>,
<a name="l00237"></a>00237                     <span class="stringliteral">&quot;6 Months&quot;</span>, <span class="stringliteral">&quot;doing stuff&quot;</span>, null, null, null, <span class="stringliteral">&quot;CIS Related&quot;</span>, 
<a name="l00238"></a>00238                     1, $id);
<a name="l00239"></a>00239     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00240"></a>00240 
<a name="l00241"></a>00241     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(1, 3, <span class="stringliteral">&quot;Network Adminstrator Assistant&quot;</span>, <span class="stringliteral">&quot;5&quot;</span>, <span class="stringliteral">&quot;2011 Spring</span>
<a name="l00242"></a>00242 <span class="stringliteral">    /Fall&quot;</span>, <span class="stringliteral">&quot;40,000/year&quot;</span>, <span class="stringliteral">&quot;One year&quot;</span>, <span class="stringliteral">&quot;Doing networking stuff&quot;</span>, null, null, null,
<a name="l00243"></a>00243                     <span class="stringliteral">&quot;CIS Related&quot;</span>, 1, $id);
<a name="l00244"></a>00244     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00245"></a>00245 
<a name="l00246"></a>00246     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(2, 4, <span class="stringliteral">&quot;Dog Washer&quot;</span>, <span class="stringliteral">&quot;4&quot;</span>, <span class="stringliteral">&quot;2011 Summer&quot;</span>, <span class="stringliteral">&quot;10/hour&quot;</span>, <span class="stringliteral">&quot;Summer&quot;</span>,
<a name="l00247"></a>00247                     <span class="stringliteral">&quot;Washing&quot;</span>, null, null, null, <span class="stringliteral">&quot;Marketing/PR&quot;</span>, 0, $id);
<a name="l00248"></a>00248     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00249"></a>00249 
<a name="l00250"></a>00250     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(2, 4, <span class="stringliteral">&quot;Dog Walker&quot;</span>, <span class="stringliteral">&quot;22&quot;</span>, <span class="stringliteral">&quot;2011 Summer&quot;</span>, <span class="stringliteral">&quot;3,000/summer&quot;</span>,
<a name="l00251"></a>00251                     <span class="stringliteral">&quot;Every summer&quot;</span>, <span class="stringliteral">&quot;Walking&quot;</span>, null, null, null, <span class="stringliteral">&quot;Communications</span>
<a name="l00252"></a>00252 <span class="stringliteral">                    Government/Political&quot;</span>, 0, $id);
<a name="l00253"></a>00253     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00254"></a>00254 
<a name="l00255"></a>00255     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(2, 4, <span class="stringliteral">&quot;Cashier&quot;</span>, <span class="stringliteral">&quot;2&quot;</span>, <span class="stringliteral">&quot;2011 Summer&quot;</span>, <span class="stringliteral">&quot;10/hour&quot;</span>, <span class="stringliteral">&quot;Summmer&quot;</span>,
<a name="l00256"></a>00256                     <span class="stringliteral">&quot;Ringing people out&quot;</span>, null, null, null, <span class="stringliteral">&quot;Finance/Economics&quot;</span>, 
<a name="l00257"></a>00257                      0, $id);
<a name="l00258"></a>00258     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00259"></a>00259 
<a name="l00260"></a>00260     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(3, 5, <span class="stringliteral">&quot;Zamboni Driver&quot;</span>, <span class="stringliteral">&quot;2&quot;</span>, <span class="stringliteral">&quot;2011 Fall&quot;</span>, <span class="stringliteral">&quot;100/hour&quot;</span>, <span class="stringliteral">&quot;One</span>
<a name="l00261"></a>00261 <span class="stringliteral">    semester&quot;</span>, <span class="stringliteral">&quot;Driving&quot;</span>, null, null, null, <span class="stringliteral">&quot;Health &amp; Human Services&quot;</span>, 0, $id);
<a name="l00262"></a>00262     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00263"></a>00263 
<a name="l00264"></a>00264     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(3, 5, <span class="stringliteral">&quot;Referee&quot;</span>, <span class="stringliteral">&quot;4&quot;</span>, <span class="stringliteral">&quot;2011 Fall&quot;</span>, <span class="stringliteral">&quot;250/week&quot;</span>, <span class="stringliteral">&quot;16 weeks&quot;</span>,
<a name="l00265"></a>00265                     <span class="stringliteral">&quot;Ice Hockey&quot;</span>, null, null, null, <span class="stringliteral">&quot;Educational Various&quot;</span>, 0, $id);
<a name="l00266"></a>00266     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00267"></a>00267 
<a name="l00268"></a>00268     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(3, 5, <span class="stringliteral">&quot;Ultimate Fan&quot;</span>, <span class="stringliteral">&quot;1&quot;</span>, <span class="stringliteral">&quot;2011 Fall/2012 Spring&quot;</span>,
<a name="l00269"></a>00269                     <span class="stringliteral">&quot;1,000,000/season&quot;</span>, <span class="stringliteral">&quot;Every season&quot;</span>, <span class="stringliteral">&quot;Ice Hockey&quot;</span>, null, null,
<a name="l00270"></a>00270                     null, <span class="stringliteral">&quot;Event Planning Communications Marketing/PR&quot;</span>, 0, $id);
<a name="l00271"></a>00271     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00272"></a>00272 
<a name="l00273"></a>00273     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(4, 6, <span class="stringliteral">&quot;Programmer&quot;</span>, <span class="stringliteral">&quot;4&quot;</span>, <span class="stringliteral">&quot;2011 Fall&quot;</span>, <span class="stringliteral">&quot;650/week&quot;</span>, <span class="stringliteral">&quot;16 weeks&quot;</span>,
<a name="l00274"></a>00274                     <span class="stringliteral">&quot;Make programs&quot;</span>, null, null, null, <span class="stringliteral">&quot;CIS Related Technology&quot;</span>, 
<a name="l00275"></a>00275                     0, $id);
<a name="l00276"></a>00276     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00277"></a>00277 
<a name="l00278"></a>00278     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(5, 7, <span class="stringliteral">&quot;Programmer&quot;</span>, <span class="stringliteral">&quot;4&quot;</span>, <span class="stringliteral">&quot;2011 Fall&quot;</span>, <span class="stringliteral">&quot;550/week&quot;</span>, <span class="stringliteral">&quot;16 weeks&quot;</span>,
<a name="l00279"></a>00279                     <span class="stringliteral">&quot;Make applications&quot;</span>, null, null, null, <span class="stringliteral">&quot;CIS Related Technology&quot;</span>,
<a name="l00280"></a>00280                     0, $id);
<a name="l00281"></a>00281     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00282"></a>00282 
<a name="l00283"></a>00283     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(6, 8, <span class="stringliteral">&quot;Researcher&quot;</span>, <span class="stringliteral">&quot;4&quot;</span>, <span class="stringliteral">&quot;2011 Fall&quot;</span>, <span class="stringliteral">&quot;1,500/semester&quot;</span>,
<a name="l00284"></a>00284                     <span class="stringliteral">&quot;16 weeks&quot;</span>, <span class="stringliteral">&quot;Research things for professors&quot;</span>, null, null, null,
<a name="l00285"></a>00285                     <span class="stringliteral">&quot;Educational Research&quot;</span>, 0, $id);
<a name="l00286"></a>00286     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00287"></a>00287 
<a name="l00288"></a>00288     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(7,9, <span class="stringliteral">&quot;Promotional Event Planner&quot;</span>, <span class="stringliteral">&quot;4&quot;</span>, <span class="stringliteral">&quot;2011 Fall&quot;</span>,
<a name="l00289"></a>00289                     <span class="stringliteral">&quot;12/hour&quot;</span>, <span class="stringliteral">&quot;16 weeks&quot;</span>, <span class="stringliteral">&quot;Ruining the country&quot;</span>, null, null, null,
<a name="l00290"></a>00290                     <span class="stringliteral">&quot;Event Planning&quot;</span>, 0, $id);
<a name="l00291"></a>00291     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00292"></a>00292 
<a name="l00293"></a>00293     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(8, 10, <span class="stringliteral">&quot;Public Relations Officer&quot;</span>, <span class="stringliteral">&quot;4&quot;</span>, <span class="stringliteral">&quot;2011 Spring&quot;</span>,
<a name="l00294"></a>00294                     <span class="stringliteral">&quot;20/hour&quot;</span>, <span class="stringliteral">&quot;12 weeks&quot;</span>, <span class="stringliteral">&quot;Help getting new facebook stuff out there&quot;</span>,
<a name="l00295"></a>00295                     null, null, null, <span class="stringliteral">&quot;Event Planning Marketing/PR Sales&quot;</span>, 0, $id);
<a name="l00296"></a>00296     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00297"></a>00297 
<a name="l00298"></a>00298     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(9, 11, <span class="stringliteral">&quot;Consultant&quot;</span>, <span class="stringliteral">&quot;4&quot;</span>, <span class="stringliteral">&quot;2011 Fall&quot;</span>, <span class="stringliteral">&quot;400/week&quot;</span>, <span class="stringliteral">&quot;Two</span>
<a name="l00299"></a>00299 <span class="stringliteral">                 projects&quot;</span>, <span class="stringliteral">&quot;Help consultanting companies&quot;</span>, null, null, null,
<a name="l00300"></a>00300                     <span class="stringliteral">&quot;Finance/Economics&quot;</span>, 0, $id);
<a name="l00301"></a>00301     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00302"></a>00302 
<a name="l00303"></a>00303     <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>(10, 12, <span class="stringliteral">&quot;Assistant to Legal&quot;</span>, <span class="stringliteral">&quot;4&quot;</span>, <span class="stringliteral">&quot;2012 Spring&quot;</span>, <span class="stringliteral">&quot;12/hour&quot;</span>,
<a name="l00304"></a>00304                     <span class="stringliteral">&quot;16 weeks&quot;</span>, <span class="stringliteral">&quot;Legal matters&quot;</span>, null, null, null, <span class="stringliteral">&quot;Legal&quot;</span>, 0, $id);
<a name="l00305"></a>00305     <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id);
<a name="l00306"></a>00306     
<a name="l00307"></a>00307 
<a name="l00308"></a>00308     
<a name="l00309"></a>00309 
<a name="l00310"></a>00310 
<a name="l00311"></a>00311 <span class="comment">//INTERNSHIP</span>
<a name="l00312"></a>00312     $id = 0;
<a name="l00313"></a>00313     <a class="code" href="db_install_sandbox_8php.html#aaa1bd797b2bbf1d78f273a6564eef022">insertInternshipData</a>(1, 1, <span class="stringliteral">&quot;35&quot;</span>, <span class="stringliteral">&quot;special&quot;</span>, <span class="stringliteral">&quot;2011 Spring&quot;</span>, $id);
<a name="l00314"></a>00314     <a class="code" href="db_install_sandbox_8php.html#aad137d4913b1f261197d5384191119b1">verifyInsertedInternship</a>($id);
<a name="l00315"></a>00315 
<a name="l00316"></a>00316     <a class="code" href="db_install_sandbox_8php.html#aaa1bd797b2bbf1d78f273a6564eef022">insertInternshipData</a>(1, 2, <span class="stringliteral">&quot;30&quot;</span>, <span class="stringliteral">&quot;special&quot;</span>, <span class="stringliteral">&quot;Fall&quot;</span>);
<a name="l00317"></a>00317     <a class="code" href="db_install_sandbox_8php.html#aad137d4913b1f261197d5384191119b1">verifyInsertedInternship</a>($id);
<a name="l00318"></a>00318 
<a name="l00319"></a>00319     <a class="code" href="db_install_sandbox_8php.html#aaa1bd797b2bbf1d78f273a6564eef022">insertInternshipData</a>(1, 3, <span class="stringliteral">&quot;25&quot;</span>, <span class="stringliteral">&quot;special&quot;</span>, <span class="stringliteral">&quot;Summer&quot;</span>);
<a name="l00320"></a>00320     <a class="code" href="db_install_sandbox_8php.html#aad137d4913b1f261197d5384191119b1">verifyInsertedInternship</a>($id);
<a name="l00321"></a>00321 
<a name="l00322"></a>00322 <span class="comment">//USER</span>
<a name="l00323"></a>00323     $id = 0;
<a name="l00324"></a>00324     <a class="code" href="db_install_sandbox_8php.html#a8f9c9f66a51056c5f49ee886ea67ef43">insertUserData</a>(<span class="stringliteral">&quot;admin&quot;</span>, <span class="stringliteral">&quot;kakIDMpFUb/KaF210KppTalJBcXUSb6&quot;</span>, <span class="stringliteral">&quot;Admin&quot;</span>, <span class="stringliteral">&quot;&quot;</span>, <span class="stringliteral">&quot;3&quot;</span>, $id);
<a name="l00325"></a>00325     <a class="code" href="db_install_sandbox_8php.html#ac0c8b6f76abda9123e486aa9a5372c0a">verifyInsertedUser</a>($id);
<a name="l00326"></a>00326 
<a name="l00327"></a>00327     <a class="code" href="db_install_sandbox_8php.html#a8f9c9f66a51056c5f49ee886ea67ef43">insertUserData</a>(<span class="stringliteral">&quot;student&quot;</span>, <span class="stringliteral">&quot;yO4y/YwffHx1cSctK4YJzcUUn7qSNzq&quot;</span>, <span class="stringliteral">&quot;Student&quot;</span>, <span class="stringliteral">&quot;&quot;</span>, <span class="stringliteral">&quot;1&quot;</span>, $id);
<a name="l00328"></a>00328     <a class="code" href="db_install_sandbox_8php.html#ac0c8b6f76abda9123e486aa9a5372c0a">verifyInsertedUser</a>($id);
<a name="l00329"></a>00329 
<a name="l00330"></a>00330     <a class="code" href="db_install_sandbox_8php.html#a8f9c9f66a51056c5f49ee886ea67ef43">insertUserData</a>(<span class="stringliteral">&quot;manager&quot;</span>, <span class="stringliteral">&quot;GE8Uuwx4VicH2S&quot;</span>, <span class="stringliteral">&quot;Kelly&quot;</span>, <span class="stringliteral">&quot;Powers&quot;</span>, <span class="stringliteral">&quot;2&quot;</span>, $id);
<a name="l00331"></a>00331     <a class="code" href="db_install_sandbox_8php.html#ac0c8b6f76abda9123e486aa9a5372c0a">verifyInsertedUser</a>($id);
<a name="l00332"></a>00332 }
<a name="l00333"></a>00333 
<a name="l00334"></a>00334 <span class="comment">//end of populateDatabase() function</span>
<a name="l00335"></a>00335 
<a name="l00336"></a><a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">00336</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#ac532770113bad6a0d344a240b5dfcfec">insertOrganizationData</a>(<a class="code" href="db-control_2inc_2db_info_8php.html#ab2fc40d43824ea3e1ce5d86dee0d763b">$name</a>, <a class="code" href="old_2internship-request_8php.html#a87b032cba06009e3467abf1c8018d960">$description</a>, $address, <a class="code" href="internship-request_8php.html#a653579f1800dead9ae026af236859831">$address1</a>, <a class="code" href="old_2internship-request_8php.html#a5b9ddd3e3a69d8901270064346bdef49">$city</a>, <a class="code" href="old_2internship-request_8php.html#ae82306c4f2d17d8dd5c7d8d916b33bed">$state</a>, <a class="code" href="old_2internship-request_8php.html#aa91be3142812d8cd4221c6f54555079b">$zip</a>, &amp;$id) {
<a name="l00337"></a>00337     $organization = <span class="keyword">new</span> <a class="code" href="class_organization.html">Organization</a>(<a class="code" href="db-control_2inc_2db_info_8php.html#ab2fc40d43824ea3e1ce5d86dee0d763b">$name</a>, <a class="code" href="old_2internship-request_8php.html#a87b032cba06009e3467abf1c8018d960">$description</a>, $address, <a class="code" href="internship-request_8php.html#a653579f1800dead9ae026af236859831">$address1</a>,
<a name="l00338"></a>00338                     <a class="code" href="old_2internship-request_8php.html#a5b9ddd3e3a69d8901270064346bdef49">$city</a>, <a class="code" href="old_2internship-request_8php.html#ae82306c4f2d17d8dd5c7d8d916b33bed">$state</a>, <a class="code" href="old_2internship-request_8php.html#aa91be3142812d8cd4221c6f54555079b">$zip</a>);
<a name="l00339"></a>00339 
<a name="l00340"></a>00340     <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_organization.html#a3d350adf56d7b3c7912f6d3d361ddc11">dbOrganization::addOrganization</a>($organization, $id);
<a name="l00341"></a>00341     <span class="keywordflow">if</span> (<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> == <span class="keyword">false</span>) {
<a name="l00342"></a>00342         die(<span class="stringliteral">&quot;Organization could not be updated with specified information.&lt;br /&gt;&quot;</span>);
<a name="l00343"></a>00343     }
<a name="l00344"></a>00344 }
<a name="l00345"></a>00345 
<a name="l00353"></a><a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">00353</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#a85b56bb0a6e1d82257b2b9b9b82387c4">verifyInsertedOrganization</a>($id) {
<a name="l00354"></a>00354     $output = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00355"></a>00355     <a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> = <a class="code" href="classdb_organization.html#a2dfd5427fef776258f77a33a83c72411">dbOrganization::getAllByID</a>($id, $output);
<a name="l00356"></a>00356     <span class="keywordflow">if</span> (<a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> == <span class="keyword">true</span>) {
<a name="l00357"></a>00357         printf(<span class="stringliteral">&quot;%s&lt;br /&gt;&quot;</span>, $output);
<a name="l00358"></a>00358     } <span class="keywordflow">else</span> {
<a name="l00359"></a>00359         $o = <span class="keyword">new</span> <a class="code" href="class_organization.html">Organization</a>($output[<span class="stringliteral">&#39;organizationName&#39;</span>], $output[<span class="stringliteral">&#39;description&#39;</span>],
<a name="l00360"></a>00360                         $output[<span class="stringliteral">&#39;address&#39;</span>], $output[<span class="stringliteral">&#39;address1&#39;</span>], $output[<span class="stringliteral">&#39;city&#39;</span>],
<a name="l00361"></a>00361                         $output[<span class="stringliteral">&#39;stateName&#39;</span>], $output[<span class="stringliteral">&#39;zip&#39;</span>]);
<a name="l00362"></a>00362         printf(<span class="stringliteral">&quot;Inserted: Organization with ID=%d has %s.&lt;br /&gt;&quot;</span>, $id,
<a name="l00363"></a>00363                 $o-&gt;printAllAttributes());
<a name="l00364"></a>00364     }
<a name="l00365"></a>00365 }
<a name="l00366"></a>00366 
<a name="l00367"></a><a class="code" href="db_install_sandbox_8php.html#a6690b1924436781ea9fc2e7d9b7a4fad">00367</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#a6690b1924436781ea9fc2e7d9b7a4fad">insertStudentData</a>($fname, $lname, <a class="code" href="db-control_2inc_2db_info_8php.html#a0eb82aa5f81cf845de4b36cd653c42cf">$username</a>, $currentGPA, $major, 
<a name="l00368"></a>00368                             $yearStatus, $graduationYear, $gotHired, &amp;$id) {
<a name="l00369"></a>00369     $s = <span class="keyword">new</span> <a class="code" href="class_student.html">Student</a>($fname, $lname, <a class="code" href="db-control_2inc_2db_info_8php.html#a0eb82aa5f81cf845de4b36cd653c42cf">$username</a>, $currentGPA, 
<a name="l00370"></a>00370             $major, $yearStatus, $graduationYear, $gotHired);
<a name="l00371"></a>00371 
<a name="l00372"></a>00372     <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_student.html#a389409c5c52d38d325ac86a45a4ecf7c">dbStudent::addStudent</a>($s, $id);
<a name="l00373"></a>00373     printf(<span class="stringliteral">&quot;-&gt;StudentID: %d&lt;br /&gt;&quot;</span>, $id);
<a name="l00374"></a>00374     <span class="keywordflow">if</span> (<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> == <span class="keyword">false</span>) {
<a name="l00375"></a>00375         die(<span class="stringliteral">&quot;Student could not be updated with specified information.&lt;br /&gt;&quot;</span>);
<a name="l00376"></a>00376     }
<a name="l00377"></a>00377 }
<a name="l00378"></a>00378 
<a name="l00379"></a><a class="code" href="db_install_sandbox_8php.html#a8094a4135599908646acd26c11023d38">00379</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#a8094a4135599908646acd26c11023d38">verifyInsertedStudent</a>($id) {
<a name="l00380"></a>00380     $output = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00381"></a>00381     <a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> = <a class="code" href="classdb_student.html#aaaca33ac319178544c7cc9df0d9f1578">dbStudent::getAllByID</a>($id, $output);
<a name="l00382"></a>00382     <span class="keywordflow">if</span> (<a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> == <span class="keyword">true</span>) {
<a name="l00383"></a>00383         printf(<span class="stringliteral">&quot;%s&lt;br /&gt;&quot;</span>, $output);
<a name="l00384"></a>00384     } <span class="keywordflow">else</span> {
<a name="l00385"></a>00385         $s = <span class="keyword">new</span> <a class="code" href="class_student.html">Student</a>($output[<span class="stringliteral">&#39;fname&#39;</span>], $output[<span class="stringliteral">&#39;lname&#39;</span>], $output[<span class="stringliteral">&#39;username&#39;</span>],
<a name="l00386"></a>00386                 $output[<span class="stringliteral">&#39;currentGPA&#39;</span>], $output[<span class="stringliteral">&#39;major&#39;</span>], $output[<span class="stringliteral">&#39;yearStatus&#39;</span>],
<a name="l00387"></a>00387                 $output[<span class="stringliteral">&#39;graduationYear&#39;</span>], $output[<span class="stringliteral">&#39;gotHired&#39;</span>]);
<a name="l00388"></a>00388         printf(<span class="stringliteral">&quot;Inserted: Student with ID=%d has %s.&lt;br /&gt;&quot;</span>, $id,
<a name="l00389"></a>00389                 $s-&gt;printAllAttributes());
<a name="l00390"></a>00390     }
<a name="l00391"></a>00391 }
<a name="l00392"></a>00392 
<a name="l00393"></a><a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">00393</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#a0d45c51f893bf0e46bb0fc2293c1862a">insertContactData</a>($organizationID, $fname, $lname, <a class="code" href="old_2internship-request_8php.html#ad634f418b20382e2802f80532d76d3cd">$email</a>, <a class="code" href="old_2internship-request_8php.html#afca642079313f7c6c3f8d4368f779882">$phone</a>, 
<a name="l00394"></a>00394                             <a class="code" href="old_2internship-request_8php.html#ade30ae71930839daaf6f83bd19081493">$ext</a>, <a class="code" href="old_2internship-request_8php.html#a1d4b86a559828926b1d8abbd581932ce">$fax</a>, &amp;$id) {
<a name="l00395"></a>00395     $contact = <span class="keyword">new</span> <a class="code" href="class_contact.html">Contact</a>($organizationID, $fname, $lname, <a class="code" href="old_2internship-request_8php.html#ad634f418b20382e2802f80532d76d3cd">$email</a>, <a class="code" href="old_2internship-request_8php.html#afca642079313f7c6c3f8d4368f779882">$phone</a>,
<a name="l00396"></a>00396                             <a class="code" href="old_2internship-request_8php.html#ade30ae71930839daaf6f83bd19081493">$ext</a>, <a class="code" href="old_2internship-request_8php.html#a1d4b86a559828926b1d8abbd581932ce">$fax</a>);
<a name="l00397"></a>00397 
<a name="l00398"></a>00398     <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_contact.html#a8d439627608a4c5850b54067b92c4021">dbContact::addContact</a>($contact, $id);
<a name="l00399"></a>00399     <span class="keywordflow">if</span> (<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> == <span class="keyword">false</span>) {
<a name="l00400"></a>00400         die(<span class="stringliteral">&quot;Contact could not be updated with specified information.&lt;br /&gt;&quot;</span>);
<a name="l00401"></a>00401     }
<a name="l00402"></a>00402 }
<a name="l00403"></a>00403 
<a name="l00404"></a><a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">00404</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#ace3a98c17bf5546cf0e1efec565c0c21">verifyInsertedContact</a>($id) {
<a name="l00405"></a>00405     $output = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00406"></a>00406     <a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> = <a class="code" href="classdb_contact.html#aaaca33ac319178544c7cc9df0d9f1578">dbContact::getAllByID</a>($id, $output);
<a name="l00407"></a>00407     <span class="keywordflow">if</span> (<a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> == <span class="keyword">true</span>) {
<a name="l00408"></a>00408         printf(<span class="stringliteral">&quot;%s&lt;br /&gt;&quot;</span>, $output);
<a name="l00409"></a>00409     } <span class="keywordflow">else</span> {
<a name="l00410"></a>00410         $c = <span class="keyword">new</span> <a class="code" href="class_contact.html">Contact</a>($output[<span class="stringliteral">&#39;organizationID&#39;</span>],
<a name="l00411"></a>00411                         $output[<span class="stringliteral">&#39;fname&#39;</span>], $output[<span class="stringliteral">&#39;lname&#39;</span>], $output[<span class="stringliteral">&#39;email&#39;</span>],
<a name="l00412"></a>00412                         $output[<span class="stringliteral">&#39;phone&#39;</span>], $output[<span class="stringliteral">&#39;ext&#39;</span>], $output[<span class="stringliteral">&#39;fax&#39;</span>]);
<a name="l00413"></a>00413         printf(<span class="stringliteral">&quot;Inserted: Contact with ID=%d has %s.&lt;br /&gt;&quot;</span>, $id,
<a name="l00414"></a>00414                 $c-&gt;printAllAttributes());
<a name="l00415"></a>00415     }
<a name="l00416"></a>00416 }
<a name="l00417"></a>00417 
<a name="l00418"></a><a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">00418</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#ad5cb73c522c1cfa2c770698444faa622">insertCategoryData</a>($categoryName, &amp;$id) {
<a name="l00419"></a>00419     <a class="code" href="internship__list__dateadded_8php.html#a18b2a8d133fa7733bf34abcc6ca2ef5b">$category</a> = <span class="keyword">new</span> <a class="code" href="class_category.html">Category</a>($categoryName);
<a name="l00420"></a>00420 
<a name="l00421"></a>00421     <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_category.html#a4fb22ba86a2ad867f7e5ecd1b62e265f">dbCategory::addCategory</a>(<a class="code" href="internship__list__dateadded_8php.html#a18b2a8d133fa7733bf34abcc6ca2ef5b">$category</a>, $id);
<a name="l00422"></a>00422     <span class="keywordflow">if</span> (<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> == <span class="keyword">false</span>) {
<a name="l00423"></a>00423         die(<span class="stringliteral">&quot;Category could not be updated with specified information.&lt;br /&gt;&quot;</span>);
<a name="l00424"></a>00424     }
<a name="l00425"></a>00425 }
<a name="l00426"></a>00426 
<a name="l00427"></a><a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">00427</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#a6775c74276c3238a5855eed71b77d5cc">verifyInsertedCategory</a>($id) {
<a name="l00428"></a>00428     $output = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00429"></a>00429     <a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> = <a class="code" href="classdb_category.html#aaaca33ac319178544c7cc9df0d9f1578">dbCategory::getAllByID</a>($id, $output);
<a name="l00430"></a>00430     <span class="keywordflow">if</span> (<a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> == <span class="keyword">true</span>) {
<a name="l00431"></a>00431         printf(<span class="stringliteral">&quot;%s&lt;br /&gt;&quot;</span>, $output);
<a name="l00432"></a>00432     } <span class="keywordflow">else</span> {
<a name="l00433"></a>00433         $c = <span class="keyword">new</span> <a class="code" href="class_category.html">Category</a>($output[<span class="stringliteral">&#39;categoryName&#39;</span>]);
<a name="l00434"></a>00434         <span class="comment">//printf(&quot;-&gt;in verifyInsertedCategory %s&quot;, $output[&#39;categoryName&#39;]);</span>
<a name="l00435"></a>00435         printf(<span class="stringliteral">&quot;Inserted: Category with ID=%d has %s.&lt;br /&gt;&quot;</span>, $id,
<a name="l00436"></a>00436                 $c-&gt;printAllAttributes());
<a name="l00437"></a>00437     }
<a name="l00438"></a>00438 }
<a name="l00439"></a>00439 
<a name="l00440"></a><a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">00440</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#a3f38aa81af7105d88300cd45b33c4e37">insertOpportunityData</a>($organizationID, $contactID, $title,
<a name="l00441"></a>00441                             $numPositionsAvailable, $semester, $payRate,
<a name="l00442"></a>00442                             $duration, <a class="code" href="old_2internship-request_8php.html#a2cc0086982fdeb92b819a5ae90f3fd0f">$responsibilities</a>,
<a name="l00443"></a>00443                             <a class="code" href="old_2internship-request_8php.html#a3ba7afce6271f471a9da3ea2e21095d2">$qualifications</a>, <a class="code" href="old_2internship-request_8php.html#ab228979b782f9b4e335a60b160d0c9ee">$instructions</a>, <a class="code" href="old_2internship-request_8php.html#a35e8cdeb473a5eb016fea893d14de951">$comments</a>,
<a name="l00444"></a>00444                             $categories, $pending, $dateAdded, &amp;$id) {
<a name="l00445"></a>00445     $opportunity = <span class="keyword">new</span> <a class="code" href="class_opportunity.html">Opportunity</a>($organizationID, $contactID, $title,
<a name="l00446"></a>00446                             $numPositionsAvailable, $semester, $payRate,
<a name="l00447"></a>00447                             $duration, <a class="code" href="old_2internship-request_8php.html#a2cc0086982fdeb92b819a5ae90f3fd0f">$responsibilities</a>,
<a name="l00448"></a>00448                             <a class="code" href="old_2internship-request_8php.html#a3ba7afce6271f471a9da3ea2e21095d2">$qualifications</a>, <a class="code" href="old_2internship-request_8php.html#ab228979b782f9b4e335a60b160d0c9ee">$instructions</a>, <a class="code" href="old_2internship-request_8php.html#a35e8cdeb473a5eb016fea893d14de951">$comments</a>,
<a name="l00449"></a>00449                             $categories, $pending, $dateAdded);
<a name="l00450"></a>00450 
<a name="l00451"></a>00451     <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_opportunity.html#aa6138359dee47e4b310d74fc17dc3ef0">dbOpportunity::addOpportunity</a>($opportunity, $id);
<a name="l00452"></a>00452     <span class="keywordflow">if</span> (<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> == <span class="keyword">false</span>) {
<a name="l00453"></a>00453         die(<span class="stringliteral">&quot;Opportunity could not be updated with specified information.&lt;br /&gt;&quot;</span>);
<a name="l00454"></a>00454     }
<a name="l00455"></a>00455 }
<a name="l00456"></a>00456 
<a name="l00457"></a><a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">00457</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#adcd6300105e6916c20b0ee323663ca4d">verifyInsertedOpportunity</a>($id) {
<a name="l00458"></a>00458     $output = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00459"></a>00459     <a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> = <a class="code" href="classdb_opportunity.html#a2dfd5427fef776258f77a33a83c72411">dbOpportunity::getAllByID</a>($id, $output);
<a name="l00460"></a>00460     <span class="keywordflow">if</span> (<a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> == <span class="keyword">true</span>) {
<a name="l00461"></a>00461         printf(<span class="stringliteral">&quot;%s&lt;br /&gt;&quot;</span>, $output);
<a name="l00462"></a>00462     } <span class="keywordflow">else</span> {
<a name="l00463"></a>00463         $opportunity = <span class="keyword">new</span> <a class="code" href="class_opportunity.html">Opportunity</a>($output[<span class="stringliteral">&#39;organizationID&#39;</span>], $output[<span class="stringliteral">&#39;contactID&#39;</span>],
<a name="l00464"></a>00464                 $output[<span class="stringliteral">&#39;title&#39;</span>], $output[<span class="stringliteral">&#39;numPositionsAvailable&#39;</span>],
<a name="l00465"></a>00465                 $output[<span class="stringliteral">&#39;semester&#39;</span>], $output[<span class="stringliteral">&#39;payRate&#39;</span>], $output[<span class="stringliteral">&#39;duration&#39;</span>],
<a name="l00466"></a>00466                 $output[<span class="stringliteral">&#39;responsibilities&#39;</span>], $output[<span class="stringliteral">&#39;qualifications&#39;</span>],
<a name="l00467"></a>00467                 $output[<span class="stringliteral">&#39;instructions&#39;</span>], $output[<span class="stringliteral">&#39;comments&#39;</span>],
<a name="l00468"></a>00468                 $output[<span class="stringliteral">&#39;categories&#39;</span>], $output[<span class="stringliteral">&#39;pending&#39;</span>], $output[<span class="stringliteral">&#39;dataAdded&#39;</span>]);
<a name="l00469"></a>00469         printf(<span class="stringliteral">&quot;Inserted: Opportunity with ID=%d has %s.&lt;br /&gt;&quot;</span>, $id,
<a name="l00470"></a>00470                 $opportunity-&gt;printAllAttributes());
<a name="l00471"></a>00471     }
<a name="l00472"></a>00472 }
<a name="l00473"></a>00473 
<a name="l00474"></a><a class="code" href="db_install_sandbox_8php.html#aaa1bd797b2bbf1d78f273a6564eef022">00474</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#aaa1bd797b2bbf1d78f273a6564eef022">insertInternshipData</a>($opportunityID, $studentID, $hours, $special,
<a name="l00475"></a>00475                               $semester, &amp;$id) {
<a name="l00476"></a>00476     $internship = <span class="keyword">new</span> <a class="code" href="class_internship.html">Internship</a>($opportunityID, $studentID, $hours, $special,
<a name="l00477"></a>00477                               $semester);
<a name="l00478"></a>00478 
<a name="l00479"></a>00479     <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_internship.html#aeb180b63f0769532646f2e2ee54418a8">dbInternship::addInternship</a>($internship, $id);
<a name="l00480"></a>00480     <span class="keywordflow">if</span> (<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> == <span class="keyword">false</span>) {
<a name="l00481"></a>00481         die(<span class="stringliteral">&quot;Internship could not be updated with specified information.&lt;br /&gt;&quot;</span>);
<a name="l00482"></a>00482     }
<a name="l00483"></a>00483 }
<a name="l00484"></a>00484 
<a name="l00485"></a><a class="code" href="db_install_sandbox_8php.html#aad137d4913b1f261197d5384191119b1">00485</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#aad137d4913b1f261197d5384191119b1">verifyInsertedInternship</a>($id) {
<a name="l00486"></a>00486     $output = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00487"></a>00487     <a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> = <a class="code" href="classdb_internship.html#aaaca33ac319178544c7cc9df0d9f1578">dbInternship::getAllByID</a>($id, $output);
<a name="l00488"></a>00488     <span class="keywordflow">if</span> (<a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> == <span class="keyword">true</span>) {
<a name="l00489"></a>00489         printf(<span class="stringliteral">&quot;%s&lt;br /&gt;&quot;</span>, $output);
<a name="l00490"></a>00490     } <span class="keywordflow">else</span> {
<a name="l00491"></a>00491         $internship = <span class="keyword">new</span> <a class="code" href="class_internship.html">Internship</a>($output[<span class="stringliteral">&#39;opportunityID&#39;</span>],
<a name="l00492"></a>00492                 $output[<span class="stringliteral">&#39;studentID&#39;</span>], $output[<span class="stringliteral">&#39;hours&#39;</span>], $output[<span class="stringliteral">&#39;special&#39;</span>],
<a name="l00493"></a>00493                 $output[<span class="stringliteral">&#39;semester&#39;</span>]);
<a name="l00494"></a>00494         <span class="comment">//printf(&quot;-&gt;in verifyInsertedInternship %s&quot;, $output[&#39;opportunityID&#39;]);</span>
<a name="l00495"></a>00495         printf(<span class="stringliteral">&quot;Inserted: Internship with ID=%d has %s.&lt;br /&gt;&quot;</span>, $id,
<a name="l00496"></a>00496                 $internship-&gt;printAllAttributes());
<a name="l00497"></a>00497     }
<a name="l00498"></a>00498 }
<a name="l00499"></a>00499 
<a name="l00500"></a><a class="code" href="db_install_sandbox_8php.html#a8f9c9f66a51056c5f49ee886ea67ef43">00500</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#a8f9c9f66a51056c5f49ee886ea67ef43">insertUserData</a>(<a class="code" href="db-control_2inc_2db_info_8php.html#a0eb82aa5f81cf845de4b36cd653c42cf">$username</a>, <a class="code" href="db-control_2inc_2db_info_8php.html#a607686ef9f99ea7c42f4f3dd3dbb2b0d">$password</a>, $fname, $lname,
<a name="l00501"></a>00501                               $permissionLevel, &amp;$id) {
<a name="l00502"></a>00502     $user = <span class="keyword">new</span> <a class="code" href="class_user.html">User</a>(<a class="code" href="db-control_2inc_2db_info_8php.html#a0eb82aa5f81cf845de4b36cd653c42cf">$username</a>, <a class="code" href="db-control_2inc_2db_info_8php.html#a607686ef9f99ea7c42f4f3dd3dbb2b0d">$password</a>, $fname, $lname,
<a name="l00503"></a>00503                               $permissionLevel);
<a name="l00504"></a>00504 
<a name="l00505"></a>00505     <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_user.html#a96e74a2261c118f3fe27bb38c91a41c8">dbUser::addUser</a>($user, $id);
<a name="l00506"></a>00506     <span class="keywordflow">if</span> (<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> == <span class="keyword">false</span>) {
<a name="l00507"></a>00507         die(<span class="stringliteral">&quot;User could not be updated with specified information.&lt;br /&gt;&quot;</span>);
<a name="l00508"></a>00508     }
<a name="l00509"></a>00509 }
<a name="l00510"></a>00510 
<a name="l00511"></a><a class="code" href="db_install_sandbox_8php.html#ac0c8b6f76abda9123e486aa9a5372c0a">00511</a> <span class="keyword">function</span> <a class="code" href="db_install_sandbox_8php.html#ac0c8b6f76abda9123e486aa9a5372c0a">verifyInsertedUser</a>($id) {
<a name="l00512"></a>00512     $output = <span class="stringliteral">&quot;&quot;</span>;
<a name="l00513"></a>00513     <a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> = <a class="code" href="classdb_user.html#aaaca33ac319178544c7cc9df0d9f1578">dbUser::getAllByID</a>($id, $output);
<a name="l00514"></a>00514     <span class="keywordflow">if</span> (<a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a> == <span class="keyword">true</span>) {
<a name="l00515"></a>00515         printf(<span class="stringliteral">&quot;%s&lt;br /&gt;&quot;</span>, $output);
<a name="l00516"></a>00516     } <span class="keywordflow">else</span> {
<a name="l00517"></a>00517         $user = <span class="keyword">new</span> <a class="code" href="class_user.html">User</a>($output[<span class="stringliteral">&#39;username&#39;</span>],
<a name="l00518"></a>00518                 $output[<span class="stringliteral">&#39;password&#39;</span>], $output[<span class="stringliteral">&#39;fname&#39;</span>], $output[<span class="stringliteral">&#39;lname&#39;</span>],
<a name="l00519"></a>00519                 $output[<span class="stringliteral">&#39;permissionLevel&#39;</span>]);
<a name="l00520"></a>00520         printf(<span class="stringliteral">&quot;Inserted: User with ID=%d has %s.&lt;br /&gt;&quot;</span>, $id,
<a name="l00521"></a>00521                 $user-&gt;printAllAttributes());
<a name="l00522"></a>00522     }
<a name="l00523"></a>00523 }
<a name="l00524"></a>00524 
<a name="l00525"></a>00525 ?&gt;
</pre></div></div>
</div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Data Structures</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>



<hr class="footer"/><address class="footer"><small>
Generated on Tue Nov 29 2011 18:18:54 for i2c by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.7.5.1
</small></address>

</body>
</html>
